Internal
| # | Message Name | Description |
|---|---|---|
| 5130 | AutoHedgeControlGateway | SpdrAutoHedgeControl contains autohedge / risk group control details. Can be uploaded from SRSE, created from ExecutionEngines, or created by SR tools. |
| 5135 | AwayStockLocateGateway | Records inserted into this table represent locates that clients have received away from SpiderRock. After validation, any away locate inserted into this table is turned into a ClientStockLocate record |
| 5140 | ExternAggGroupGateway | This table allows clients to enter start-of-day positions, and quantity bot/sld today for each market. AggGroup is a code issued by SpiderRock to indentify the aggregation group that the reported positions and trades belong to. This will usually be your SpiderRock assigned ClientFirm code unless your firm has more than one aggregation unit. Note that start-of-day positions can be truncated if the truncation will not affect order marking. Contact SpiderRock support for details if this is what you intend. |
| 5145 | FutAwayTktGateway | FutAwayTktGateway inserts are validated and convered to away SpdrParentExecution records and published. If successfully published they will be visible in the SpdrParentExecution table and on SpiderRock GUI tools. Replaces are allowed but they are functionally identical to updates in that only the fillPrice and fillQuantity fields are actually changed. |
| 5150 | FutOrderGateway | Records inserted, updated, or replaced into the FutureOrderGateway table are validated and then converted to SpdrParentOrder records and forwarded to the appropriate execution engine for futher processing. Parent orders can be inserted as either active/ready or in a wait start mode that requires subsequent release. See the SpiderRock Execution Engine concept guide for more details. |
| 5155 | MLegOrderGateway | Records inserted, updated, or replaced into the MLegOrderGateway table are validated and then converted to SpdrParentOrder records and forwarded to the appropriate execution engine for futher processing. Parent orders can be inserted as either active/ready or in a wait start mode that requires subsequent release. See the SpiderRock Execution Engine concept guide for more details. |
| 3355 | MLinkCacheRequest | |
| 5900 | NetPulse | |
| 5160 | OptAwayTktGateway | OptAwayTktGateway inserts are validated and convered to away SpdrParentExecution records and published. If successfully published they will be visible in the SpdrParentExecution table and on SpiderRock GUI tools. Replaces are allowed but they are functionally identical to updates in that only the fillPrice and fillQuantity fields are actually changed. |
| 5165 | OptOrderGateway | Records inserted, updated, or replaced into the OptionOrderGateway table are validated and then converted to SpdrParentOrder records and forwarded to the appropriate execution engine for futher processing. Parent orders can be inserted as either active/ready or in a wait start mode that requires subsequent release. See the SpiderRock Execution Engine concept guide for more details. |
| 5030 | OptionCalculator | This table allows custom option pricing based on either user or SR supplied input values. |
| 2765 | OptionExchOrder | |
| 2770 | OptionExchPrint | |
| 5035 | OptionImpliedPair | This table contains current live NBBO prices and implied volatilites as well as greeks and SpiderRock surface volatilities/prices for all call/put pairs in the market. |
| 5045 | OptionImpliedVol | This table contains option implied volatilities computed using fast/accurate calcuation methods while the SELECT is processing. Note that if you need even faster queries that cover a large number of strikes you may be better off using the OptionImpliedQuoteAdj table as it is pre-computed. |
| 5046 | OptionImpliedVolV4 | This table contains option implied volatilities computed using fast/accurate calcuation methods while the SELECT is processing. Note that if you need even faster queries that cover a large number of strikes you may be better off using the OptionImpliedQuoteAdj table as it is pre-computed. |
| 2810 | OptionPrintMarkup | OptionPrintMarkup records contain every option print along with quote, surface details at print time |
| 5180 | ParentOrderGateway | Records inserted, updated, or replaced into the ParentOrderGateway table are validated and then converted to SpdrParentOrder records and forwarded to the appropriate execution engine for futher processing. Parent orders can be inserted as either active/ready or in a wait start mode that requires subsequent release. See the SpiderRock Execution Engine concept guide for more details. |
| 5185 | ParentOrderGatewayExt | Records inserted, updated, or replaced into the ParentOrderGatewayExt table are validated and then converted to SpdrParentOrder records and forwarded to the appropriate execution engine for futher processing. Parent orders can be inserted as either active/ready or in a wait start mode that requires subsequent release. See the SpiderRock Execution Engine concept guide for more details. |
| 5190 | SecDefRequestGateway | |
| 4000 | SpdrFixParentCancel | Records inserted into this table causes the corresponding parent order to be cancelled if it is active and cancellable. |
| 4005 | SpdrFixParentExecution | |
| 4010 | SpdrFixParentReject | Record indicates that either a SpdrParentOrder (Add or Replace) or FixParentCancel request failed |
| 4060 | SpdrParentBrkrDetail | SpdrParentBrkrDetail records are created/published by SpiderRock Execution Engines. Each record describes the current active detail of a single parent broker. |
| 5355 | SpdrStrategyOrderLeggerX | |
| 5365 | SpdrStrategyReportLegX | |
| 5360 | SpdrStrategyReportLeggerX | |
| 5375 | SpdrStrategyStateLegX | |
| 5370 | SpdrStrategyStateLeggerX | |
| 2920 | SpreadExchPrint | |
| 5220 | StkAwayTktGateway | StkAwayTktGateway inserts are validated and convered to away SpdrParentExecution records and published. If successfully published they will be visible in the SpdrParentExecution table and on SpiderRock GUI tools. Replaces are allowed but they are functionally identical to updates in that only the fillPrice and fillQuantity fields are actually changed. |
| 5225 | StkOrderGateway | Records inserted, updated, or replaced into the StockOrderGateway table are validated and then converted to SpdrParentOrder records and forwarded to the appropriate execution engine for futher processing. Parent orders can be inserted as either active/ready or in a wait start mode that requires subsequent release. See the SpiderRock Execution Engine concept guide for more details. |
| 5230 | StockLocateRequestGateway | Records inserted into this gateway become locate requests and are visible in the StockLocateRequest table. |
| 5750 | ULinkContextEvent | |
| 5235 | ULinkContextGateway |